*GET DATA.
GET DATA /TYPE=XLSX 
  /FILE='/CASEY/UM_drive/data/pitch and leadership ability/109th senate data.xlsx' 
  /SHEET=name 'Senate Power Rankings 2008' 
  /CELLRANGE=full 
  /READNAMES=on 
  /ASSUMEDSTRWIDTH=32767. 
EXECUTE. 
DATASET NAME DataSet1 WINDOW=FRONT.

*DESCRIPTIVES.
   *pooled.
descriptives rank sccore pitch_ave min_ave max_ave
   *by sex.
T-TEST GROUPS=female(0 1) 
  /MISSING=ANALYSIS 
  /VARIABLES=rank score pitch_ave min_ave max_ave 
  /CRITERIA=CI(.95).

*CORRELATIONS.
CORRELATIONS 
  /VARIABLES=rank score pitch_ave min_ave max_ave 
  /PRINT=TWOTAIL NOSIG 
  /MISSING=PAIRWISE.

*TEST FOR SEX EFFECTS.
   *int term.
compute pitch_sex=pitch_ave*female.
DESCRIPTIVES  pitch_sex.
   *rank.
REGRESSION 
  /MISSING LISTWISE 
  /STATISTICS COEFF OUTS R ANOVA 
  /CRITERIA=PIN(.05) POUT(.10) 
  /NOORIGIN 
  /DEPENDENT rank 
  /METHOD=ENTER female pitch_ave pitch_sex.
   *score.
REGRESSION 
  /MISSING LISTWISE 
  /STATISTICS COEFF OUTS R ANOVA 
  /CRITERIA=PIN(.05) POUT(.10) 
  /NOORIGIN 
  /DEPENDENT score 
  /METHOD=ENTER female pitch_ave pitch_sex.

*LOOK AT LEADERSHIP PAC MONEY, AND FEC RECORDS.
CORRELATIONS 
  /VARIABLES=lead_PAC money pitch_ave min_ave max_ave 
  /PRINT=TWOTAIL NOSIG 
  /MISSING=PAIRWISE.

